SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 311;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('311', 'Cash Crusaders Scottburgh','Cash Crusaders Scottburgh','Cash Crusaders Richards Bay (Pty) Ltd','Shop UL02, Scottburgh Mall, Portion 219, Farm Lot 14 Number 1664','TBA','4700275276','2016/041019/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders Scottburgh',CompanyName = 'Cash Crusaders Scottburgh', TradingAs = 'Cash Crusaders Richards Bay (Pty) Ltd', Address='Shop UL02, Scottburgh Mall, Portion 219, Farm Lot 14 Number 1664', ContactNo = 'TBA', VATRegNo = '4700275276',RegNo = '2016/041019/07', StoreEmailAddress = 'TBA' where Store_ID = 311;
 END


 SET IDENTITY_INSERT [dbo].[store] off